package com.crm.miaohe.model;

import java.time.LocalDateTime;
import java.util.ArrayList;
import java.util.List;

public class TblCustomerExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public TblCustomerExample() {
        oredCriteria = new ArrayList<>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("name is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("name is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("name =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("name <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("name >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("name >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("name <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("name <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("name like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("name not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("name in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("name not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("name between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("name not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeIsNull() {
            addCriterion("organization_code is null");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeIsNotNull() {
            addCriterion("organization_code is not null");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeEqualTo(String value) {
            addCriterion("organization_code =", value, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeNotEqualTo(String value) {
            addCriterion("organization_code <>", value, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeGreaterThan(String value) {
            addCriterion("organization_code >", value, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeGreaterThanOrEqualTo(String value) {
            addCriterion("organization_code >=", value, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeLessThan(String value) {
            addCriterion("organization_code <", value, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeLessThanOrEqualTo(String value) {
            addCriterion("organization_code <=", value, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeLike(String value) {
            addCriterion("organization_code like", value, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeNotLike(String value) {
            addCriterion("organization_code not like", value, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeIn(List<String> values) {
            addCriterion("organization_code in", values, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeNotIn(List<String> values) {
            addCriterion("organization_code not in", values, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeBetween(String value1, String value2) {
            addCriterion("organization_code between", value1, value2, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeNotBetween(String value1, String value2) {
            addCriterion("organization_code not between", value1, value2, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationNameIsNull() {
            addCriterion("organization_name is null");
            return (Criteria) this;
        }

        public Criteria andOrganizationNameIsNotNull() {
            addCriterion("organization_name is not null");
            return (Criteria) this;
        }

        public Criteria andOrganizationNameEqualTo(String value) {
            addCriterion("organization_name =", value, "organizationName");
            return (Criteria) this;
        }

        public Criteria andOrganizationNameNotEqualTo(String value) {
            addCriterion("organization_name <>", value, "organizationName");
            return (Criteria) this;
        }

        public Criteria andOrganizationNameGreaterThan(String value) {
            addCriterion("organization_name >", value, "organizationName");
            return (Criteria) this;
        }

        public Criteria andOrganizationNameGreaterThanOrEqualTo(String value) {
            addCriterion("organization_name >=", value, "organizationName");
            return (Criteria) this;
        }

        public Criteria andOrganizationNameLessThan(String value) {
            addCriterion("organization_name <", value, "organizationName");
            return (Criteria) this;
        }

        public Criteria andOrganizationNameLessThanOrEqualTo(String value) {
            addCriterion("organization_name <=", value, "organizationName");
            return (Criteria) this;
        }

        public Criteria andOrganizationNameLike(String value) {
            addCriterion("organization_name like", value, "organizationName");
            return (Criteria) this;
        }

        public Criteria andOrganizationNameNotLike(String value) {
            addCriterion("organization_name not like", value, "organizationName");
            return (Criteria) this;
        }

        public Criteria andOrganizationNameIn(List<String> values) {
            addCriterion("organization_name in", values, "organizationName");
            return (Criteria) this;
        }

        public Criteria andOrganizationNameNotIn(List<String> values) {
            addCriterion("organization_name not in", values, "organizationName");
            return (Criteria) this;
        }

        public Criteria andOrganizationNameBetween(String value1, String value2) {
            addCriterion("organization_name between", value1, value2, "organizationName");
            return (Criteria) this;
        }

        public Criteria andOrganizationNameNotBetween(String value1, String value2) {
            addCriterion("organization_name not between", value1, value2, "organizationName");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeCodeIsNull() {
            addCriterion("customer_type_code is null");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeCodeIsNotNull() {
            addCriterion("customer_type_code is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeCodeEqualTo(String value) {
            addCriterion("customer_type_code =", value, "customerTypeCode");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeCodeNotEqualTo(String value) {
            addCriterion("customer_type_code <>", value, "customerTypeCode");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeCodeGreaterThan(String value) {
            addCriterion("customer_type_code >", value, "customerTypeCode");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeCodeGreaterThanOrEqualTo(String value) {
            addCriterion("customer_type_code >=", value, "customerTypeCode");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeCodeLessThan(String value) {
            addCriterion("customer_type_code <", value, "customerTypeCode");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeCodeLessThanOrEqualTo(String value) {
            addCriterion("customer_type_code <=", value, "customerTypeCode");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeCodeLike(String value) {
            addCriterion("customer_type_code like", value, "customerTypeCode");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeCodeNotLike(String value) {
            addCriterion("customer_type_code not like", value, "customerTypeCode");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeCodeIn(List<String> values) {
            addCriterion("customer_type_code in", values, "customerTypeCode");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeCodeNotIn(List<String> values) {
            addCriterion("customer_type_code not in", values, "customerTypeCode");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeCodeBetween(String value1, String value2) {
            addCriterion("customer_type_code between", value1, value2, "customerTypeCode");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeCodeNotBetween(String value1, String value2) {
            addCriterion("customer_type_code not between", value1, value2, "customerTypeCode");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeNameIsNull() {
            addCriterion("customer_type_name is null");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeNameIsNotNull() {
            addCriterion("customer_type_name is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeNameEqualTo(String value) {
            addCriterion("customer_type_name =", value, "customerTypeName");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeNameNotEqualTo(String value) {
            addCriterion("customer_type_name <>", value, "customerTypeName");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeNameGreaterThan(String value) {
            addCriterion("customer_type_name >", value, "customerTypeName");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeNameGreaterThanOrEqualTo(String value) {
            addCriterion("customer_type_name >=", value, "customerTypeName");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeNameLessThan(String value) {
            addCriterion("customer_type_name <", value, "customerTypeName");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeNameLessThanOrEqualTo(String value) {
            addCriterion("customer_type_name <=", value, "customerTypeName");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeNameLike(String value) {
            addCriterion("customer_type_name like", value, "customerTypeName");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeNameNotLike(String value) {
            addCriterion("customer_type_name not like", value, "customerTypeName");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeNameIn(List<String> values) {
            addCriterion("customer_type_name in", values, "customerTypeName");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeNameNotIn(List<String> values) {
            addCriterion("customer_type_name not in", values, "customerTypeName");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeNameBetween(String value1, String value2) {
            addCriterion("customer_type_name between", value1, value2, "customerTypeName");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeNameNotBetween(String value1, String value2) {
            addCriterion("customer_type_name not between", value1, value2, "customerTypeName");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeChildCodeIsNull() {
            addCriterion("customer_type_child_code is null");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeChildCodeIsNotNull() {
            addCriterion("customer_type_child_code is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeChildCodeEqualTo(String value) {
            addCriterion("customer_type_child_code =", value, "customerTypeChildCode");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeChildCodeNotEqualTo(String value) {
            addCriterion("customer_type_child_code <>", value, "customerTypeChildCode");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeChildCodeGreaterThan(String value) {
            addCriterion("customer_type_child_code >", value, "customerTypeChildCode");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeChildCodeGreaterThanOrEqualTo(String value) {
            addCriterion("customer_type_child_code >=", value, "customerTypeChildCode");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeChildCodeLessThan(String value) {
            addCriterion("customer_type_child_code <", value, "customerTypeChildCode");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeChildCodeLessThanOrEqualTo(String value) {
            addCriterion("customer_type_child_code <=", value, "customerTypeChildCode");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeChildCodeLike(String value) {
            addCriterion("customer_type_child_code like", value, "customerTypeChildCode");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeChildCodeNotLike(String value) {
            addCriterion("customer_type_child_code not like", value, "customerTypeChildCode");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeChildCodeIn(List<String> values) {
            addCriterion("customer_type_child_code in", values, "customerTypeChildCode");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeChildCodeNotIn(List<String> values) {
            addCriterion("customer_type_child_code not in", values, "customerTypeChildCode");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeChildCodeBetween(String value1, String value2) {
            addCriterion("customer_type_child_code between", value1, value2, "customerTypeChildCode");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeChildCodeNotBetween(String value1, String value2) {
            addCriterion("customer_type_child_code not between", value1, value2, "customerTypeChildCode");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeChildNameIsNull() {
            addCriterion("customer_type_child_name is null");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeChildNameIsNotNull() {
            addCriterion("customer_type_child_name is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeChildNameEqualTo(String value) {
            addCriterion("customer_type_child_name =", value, "customerTypeChildName");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeChildNameNotEqualTo(String value) {
            addCriterion("customer_type_child_name <>", value, "customerTypeChildName");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeChildNameGreaterThan(String value) {
            addCriterion("customer_type_child_name >", value, "customerTypeChildName");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeChildNameGreaterThanOrEqualTo(String value) {
            addCriterion("customer_type_child_name >=", value, "customerTypeChildName");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeChildNameLessThan(String value) {
            addCriterion("customer_type_child_name <", value, "customerTypeChildName");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeChildNameLessThanOrEqualTo(String value) {
            addCriterion("customer_type_child_name <=", value, "customerTypeChildName");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeChildNameLike(String value) {
            addCriterion("customer_type_child_name like", value, "customerTypeChildName");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeChildNameNotLike(String value) {
            addCriterion("customer_type_child_name not like", value, "customerTypeChildName");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeChildNameIn(List<String> values) {
            addCriterion("customer_type_child_name in", values, "customerTypeChildName");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeChildNameNotIn(List<String> values) {
            addCriterion("customer_type_child_name not in", values, "customerTypeChildName");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeChildNameBetween(String value1, String value2) {
            addCriterion("customer_type_child_name between", value1, value2, "customerTypeChildName");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeChildNameNotBetween(String value1, String value2) {
            addCriterion("customer_type_child_name not between", value1, value2, "customerTypeChildName");
            return (Criteria) this;
        }

        public Criteria andCustomerNumIsNull() {
            addCriterion("customer_num is null");
            return (Criteria) this;
        }

        public Criteria andCustomerNumIsNotNull() {
            addCriterion("customer_num is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerNumEqualTo(String value) {
            addCriterion("customer_num =", value, "customerNum");
            return (Criteria) this;
        }

        public Criteria andCustomerNumNotEqualTo(String value) {
            addCriterion("customer_num <>", value, "customerNum");
            return (Criteria) this;
        }

        public Criteria andCustomerNumGreaterThan(String value) {
            addCriterion("customer_num >", value, "customerNum");
            return (Criteria) this;
        }

        public Criteria andCustomerNumGreaterThanOrEqualTo(String value) {
            addCriterion("customer_num >=", value, "customerNum");
            return (Criteria) this;
        }

        public Criteria andCustomerNumLessThan(String value) {
            addCriterion("customer_num <", value, "customerNum");
            return (Criteria) this;
        }

        public Criteria andCustomerNumLessThanOrEqualTo(String value) {
            addCriterion("customer_num <=", value, "customerNum");
            return (Criteria) this;
        }

        public Criteria andCustomerNumLike(String value) {
            addCriterion("customer_num like", value, "customerNum");
            return (Criteria) this;
        }

        public Criteria andCustomerNumNotLike(String value) {
            addCriterion("customer_num not like", value, "customerNum");
            return (Criteria) this;
        }

        public Criteria andCustomerNumIn(List<String> values) {
            addCriterion("customer_num in", values, "customerNum");
            return (Criteria) this;
        }

        public Criteria andCustomerNumNotIn(List<String> values) {
            addCriterion("customer_num not in", values, "customerNum");
            return (Criteria) this;
        }

        public Criteria andCustomerNumBetween(String value1, String value2) {
            addCriterion("customer_num between", value1, value2, "customerNum");
            return (Criteria) this;
        }

        public Criteria andCustomerNumNotBetween(String value1, String value2) {
            addCriterion("customer_num not between", value1, value2, "customerNum");
            return (Criteria) this;
        }

        public Criteria andCustomerIdIsNull() {
            addCriterion("customer_id is null");
            return (Criteria) this;
        }

        public Criteria andCustomerIdIsNotNull() {
            addCriterion("customer_id is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerIdEqualTo(Long value) {
            addCriterion("customer_id =", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotEqualTo(Integer value) {
            addCriterion("customer_id <>", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdGreaterThan(Integer value) {
            addCriterion("customer_id >", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("customer_id >=", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdLessThan(Integer value) {
            addCriterion("customer_id <", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdLessThanOrEqualTo(Integer value) {
            addCriterion("customer_id <=", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdIn(List<Integer> values) {
            addCriterion("customer_id in", values, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotIn(List<Integer> values) {
            addCriterion("customer_id not in", values, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdBetween(Integer value1, Integer value2) {
            addCriterion("customer_id between", value1, value2, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotBetween(Integer value1, Integer value2) {
            addCriterion("customer_id not between", value1, value2, "customerId");
            return (Criteria) this;
        }

        public Criteria andBizCodeIsNull() {
            addCriterion("biz_code is null");
            return (Criteria) this;
        }

        public Criteria andBizCodeIsNotNull() {
            addCriterion("biz_code is not null");
            return (Criteria) this;
        }

        public Criteria andBizCodeEqualTo(String value) {
            addCriterion("biz_code =", value, "bizCode");
            return (Criteria) this;
        }

        public Criteria andBizCodeNotEqualTo(String value) {
            addCriterion("biz_code <>", value, "bizCode");
            return (Criteria) this;
        }

        public Criteria andBizCodeGreaterThan(String value) {
            addCriterion("biz_code >", value, "bizCode");
            return (Criteria) this;
        }

        public Criteria andBizCodeGreaterThanOrEqualTo(String value) {
            addCriterion("biz_code >=", value, "bizCode");
            return (Criteria) this;
        }

        public Criteria andBizCodeLessThan(String value) {
            addCriterion("biz_code <", value, "bizCode");
            return (Criteria) this;
        }

        public Criteria andBizCodeLessThanOrEqualTo(String value) {
            addCriterion("biz_code <=", value, "bizCode");
            return (Criteria) this;
        }

        public Criteria andBizCodeLike(String value) {
            addCriterion("biz_code like", value, "bizCode");
            return (Criteria) this;
        }

        public Criteria andBizCodeNotLike(String value) {
            addCriterion("biz_code not like", value, "bizCode");
            return (Criteria) this;
        }

        public Criteria andBizCodeIn(List<String> values) {
            addCriterion("biz_code in", values, "bizCode");
            return (Criteria) this;
        }

        public Criteria andBizCodeNotIn(List<String> values) {
            addCriterion("biz_code not in", values, "bizCode");
            return (Criteria) this;
        }

        public Criteria andBizCodeBetween(String value1, String value2) {
            addCriterion("biz_code between", value1, value2, "bizCode");
            return (Criteria) this;
        }

        public Criteria andBizCodeNotBetween(String value1, String value2) {
            addCriterion("biz_code not between", value1, value2, "bizCode");
            return (Criteria) this;
        }

        public Criteria andBizNameIsNull() {
            addCriterion("biz_name is null");
            return (Criteria) this;
        }

        public Criteria andBizNameIsNotNull() {
            addCriterion("biz_name is not null");
            return (Criteria) this;
        }

        public Criteria andBizNameEqualTo(String value) {
            addCriterion("biz_name =", value, "bizName");
            return (Criteria) this;
        }

        public Criteria andBizNameNotEqualTo(String value) {
            addCriterion("biz_name <>", value, "bizName");
            return (Criteria) this;
        }

        public Criteria andBizNameGreaterThan(String value) {
            addCriterion("biz_name >", value, "bizName");
            return (Criteria) this;
        }

        public Criteria andBizNameGreaterThanOrEqualTo(String value) {
            addCriterion("biz_name >=", value, "bizName");
            return (Criteria) this;
        }

        public Criteria andBizNameLessThan(String value) {
            addCriterion("biz_name <", value, "bizName");
            return (Criteria) this;
        }

        public Criteria andBizNameLessThanOrEqualTo(String value) {
            addCriterion("biz_name <=", value, "bizName");
            return (Criteria) this;
        }

        public Criteria andBizNameLike(String value) {
            addCriterion("biz_name like", value, "bizName");
            return (Criteria) this;
        }

        public Criteria andBizNameNotLike(String value) {
            addCriterion("biz_name not like", value, "bizName");
            return (Criteria) this;
        }

        public Criteria andBizNameIn(List<String> values) {
            addCriterion("biz_name in", values, "bizName");
            return (Criteria) this;
        }

        public Criteria andBizNameNotIn(List<String> values) {
            addCriterion("biz_name not in", values, "bizName");
            return (Criteria) this;
        }

        public Criteria andBizNameBetween(String value1, String value2) {
            addCriterion("biz_name between", value1, value2, "bizName");
            return (Criteria) this;
        }

        public Criteria andBizNameNotBetween(String value1, String value2) {
            addCriterion("biz_name not between", value1, value2, "bizName");
            return (Criteria) this;
        }

        public Criteria andCustomerKindCodeIsNull() {
            addCriterion("customer_kind_code is null");
            return (Criteria) this;
        }

        public Criteria andCustomerKindCodeIsNotNull() {
            addCriterion("customer_kind_code is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerKindCodeEqualTo(String value) {
            addCriterion("customer_kind_code =", value, "customerKindCode");
            return (Criteria) this;
        }

        public Criteria andCustomerKindCodeNotEqualTo(String value) {
            addCriterion("customer_kind_code <>", value, "customerKindCode");
            return (Criteria) this;
        }

        public Criteria andCustomerKindCodeGreaterThan(String value) {
            addCriterion("customer_kind_code >", value, "customerKindCode");
            return (Criteria) this;
        }

        public Criteria andCustomerKindCodeGreaterThanOrEqualTo(String value) {
            addCriterion("customer_kind_code >=", value, "customerKindCode");
            return (Criteria) this;
        }

        public Criteria andCustomerKindCodeLessThan(String value) {
            addCriterion("customer_kind_code <", value, "customerKindCode");
            return (Criteria) this;
        }

        public Criteria andCustomerKindCodeLessThanOrEqualTo(String value) {
            addCriterion("customer_kind_code <=", value, "customerKindCode");
            return (Criteria) this;
        }

        public Criteria andCustomerKindCodeLike(String value) {
            addCriterion("customer_kind_code like", value, "customerKindCode");
            return (Criteria) this;
        }

        public Criteria andCustomerKindCodeNotLike(String value) {
            addCriterion("customer_kind_code not like", value, "customerKindCode");
            return (Criteria) this;
        }

        public Criteria andCustomerKindCodeIn(List<String> values) {
            addCriterion("customer_kind_code in", values, "customerKindCode");
            return (Criteria) this;
        }

        public Criteria andCustomerKindCodeNotIn(List<String> values) {
            addCriterion("customer_kind_code not in", values, "customerKindCode");
            return (Criteria) this;
        }

        public Criteria andCustomerKindCodeBetween(String value1, String value2) {
            addCriterion("customer_kind_code between", value1, value2, "customerKindCode");
            return (Criteria) this;
        }

        public Criteria andCustomerKindCodeNotBetween(String value1, String value2) {
            addCriterion("customer_kind_code not between", value1, value2, "customerKindCode");
            return (Criteria) this;
        }

        public Criteria andCustomerKindNameIsNull() {
            addCriterion("customer_kind_name is null");
            return (Criteria) this;
        }

        public Criteria andCustomerKindNameIsNotNull() {
            addCriterion("customer_kind_name is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerKindNameEqualTo(String value) {
            addCriterion("customer_kind_name =", value, "customerKindName");
            return (Criteria) this;
        }

        public Criteria andCustomerKindNameNotEqualTo(String value) {
            addCriterion("customer_kind_name <>", value, "customerKindName");
            return (Criteria) this;
        }

        public Criteria andCustomerKindNameGreaterThan(String value) {
            addCriterion("customer_kind_name >", value, "customerKindName");
            return (Criteria) this;
        }

        public Criteria andCustomerKindNameGreaterThanOrEqualTo(String value) {
            addCriterion("customer_kind_name >=", value, "customerKindName");
            return (Criteria) this;
        }

        public Criteria andCustomerKindNameLessThan(String value) {
            addCriterion("customer_kind_name <", value, "customerKindName");
            return (Criteria) this;
        }

        public Criteria andCustomerKindNameLessThanOrEqualTo(String value) {
            addCriterion("customer_kind_name <=", value, "customerKindName");
            return (Criteria) this;
        }

        public Criteria andCustomerKindNameLike(String value) {
            addCriterion("customer_kind_name like", value, "customerKindName");
            return (Criteria) this;
        }

        public Criteria andCustomerKindNameNotLike(String value) {
            addCriterion("customer_kind_name not like", value, "customerKindName");
            return (Criteria) this;
        }

        public Criteria andCustomerKindNameIn(List<String> values) {
            addCriterion("customer_kind_name in", values, "customerKindName");
            return (Criteria) this;
        }

        public Criteria andCustomerKindNameNotIn(List<String> values) {
            addCriterion("customer_kind_name not in", values, "customerKindName");
            return (Criteria) this;
        }

        public Criteria andCustomerKindNameBetween(String value1, String value2) {
            addCriterion("customer_kind_name between", value1, value2, "customerKindName");
            return (Criteria) this;
        }

        public Criteria andCustomerKindNameNotBetween(String value1, String value2) {
            addCriterion("customer_kind_name not between", value1, value2, "customerKindName");
            return (Criteria) this;
        }

        public Criteria andPrincipalIsNull() {
            addCriterion("principal is null");
            return (Criteria) this;
        }

        public Criteria andPrincipalIsNotNull() {
            addCriterion("principal is not null");
            return (Criteria) this;
        }

        public Criteria andPrincipalEqualTo(String value) {
            addCriterion("principal =", value, "principal");
            return (Criteria) this;
        }

        public Criteria andPrincipalNotEqualTo(String value) {
            addCriterion("principal <>", value, "principal");
            return (Criteria) this;
        }

        public Criteria andPrincipalGreaterThan(String value) {
            addCriterion("principal >", value, "principal");
            return (Criteria) this;
        }

        public Criteria andPrincipalGreaterThanOrEqualTo(String value) {
            addCriterion("principal >=", value, "principal");
            return (Criteria) this;
        }

        public Criteria andPrincipalLessThan(String value) {
            addCriterion("principal <", value, "principal");
            return (Criteria) this;
        }

        public Criteria andPrincipalLessThanOrEqualTo(String value) {
            addCriterion("principal <=", value, "principal");
            return (Criteria) this;
        }

        public Criteria andPrincipalLike(String value) {
            addCriterion("principal like", value, "principal");
            return (Criteria) this;
        }

        public Criteria andPrincipalNotLike(String value) {
            addCriterion("principal not like", value, "principal");
            return (Criteria) this;
        }

        public Criteria andPrincipalIn(List<String> values) {
            addCriterion("principal in", values, "principal");
            return (Criteria) this;
        }

        public Criteria andPrincipalNotIn(List<String> values) {
            addCriterion("principal not in", values, "principal");
            return (Criteria) this;
        }

        public Criteria andPrincipalBetween(String value1, String value2) {
            addCriterion("principal between", value1, value2, "principal");
            return (Criteria) this;
        }

        public Criteria andPrincipalNotBetween(String value1, String value2) {
            addCriterion("principal not between", value1, value2, "principal");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberIsNull() {
            addCriterion("phone_number is null");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberIsNotNull() {
            addCriterion("phone_number is not null");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberEqualTo(String value) {
            addCriterion("phone_number =", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberNotEqualTo(String value) {
            addCriterion("phone_number <>", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberGreaterThan(String value) {
            addCriterion("phone_number >", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberGreaterThanOrEqualTo(String value) {
            addCriterion("phone_number >=", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberLessThan(String value) {
            addCriterion("phone_number <", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberLessThanOrEqualTo(String value) {
            addCriterion("phone_number <=", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberLike(String value) {
            addCriterion("phone_number like", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberNotLike(String value) {
            addCriterion("phone_number not like", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberIn(List<String> values) {
            addCriterion("phone_number in", values, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberNotIn(List<String> values) {
            addCriterion("phone_number not in", values, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberBetween(String value1, String value2) {
            addCriterion("phone_number between", value1, value2, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberNotBetween(String value1, String value2) {
            addCriterion("phone_number not between", value1, value2, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNull() {
            addCriterion("province is null");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNotNull() {
            addCriterion("province is not null");
            return (Criteria) this;
        }

        public Criteria andProvinceEqualTo(Long value) {
            addCriterion("province =", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotEqualTo(Long value) {
            addCriterion("province <>", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThan(Long value) {
            addCriterion("province >", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThanOrEqualTo(Long value) {
            addCriterion("province >=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThan(Long value) {
            addCriterion("province <", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThanOrEqualTo(Long value) {
            addCriterion("province <=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceIn(List<Long> values) {
            addCriterion("province in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotIn(List<Long> values) {
            addCriterion("province not in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceBetween(Long value1, Long value2) {
            addCriterion("province between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotBetween(Long value1, Long value2) {
            addCriterion("province not between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andCityIsNull() {
            addCriterion("city is null");
            return (Criteria) this;
        }

        public Criteria andCityIsNotNull() {
            addCriterion("city is not null");
            return (Criteria) this;
        }

        public Criteria andCityEqualTo(Long value) {
            addCriterion("city =", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotEqualTo(Long value) {
            addCriterion("city <>", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThan(Long value) {
            addCriterion("city >", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThanOrEqualTo(Long value) {
            addCriterion("city >=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThan(Long value) {
            addCriterion("city <", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThanOrEqualTo(Long value) {
            addCriterion("city <=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityIn(List<Long> values) {
            addCriterion("city in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotIn(List<Long> values) {
            addCriterion("city not in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityBetween(Long value1, Long value2) {
            addCriterion("city between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotBetween(Long value1, Long value2) {
            addCriterion("city not between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andDistrictIsNull() {
            addCriterion("district is null");
            return (Criteria) this;
        }

        public Criteria andDistrictIsNotNull() {
            addCriterion("district is not null");
            return (Criteria) this;
        }

        public Criteria andDistrictEqualTo(Long value) {
            addCriterion("district =", value, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictNotEqualTo(Long value) {
            addCriterion("district <>", value, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictGreaterThan(Long value) {
            addCriterion("district >", value, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictGreaterThanOrEqualTo(Long value) {
            addCriterion("district >=", value, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictLessThan(Long value) {
            addCriterion("district <", value, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictLessThanOrEqualTo(Long value) {
            addCriterion("district <=", value, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictIn(List<Long> values) {
            addCriterion("district in", values, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictNotIn(List<Long> values) {
            addCriterion("district not in", values, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictBetween(Long value1, Long value2) {
            addCriterion("district between", value1, value2, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictNotBetween(Long value1, Long value2) {
            addCriterion("district not between", value1, value2, "district");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("address is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("address is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("address =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("address <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("address >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("address >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("address <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("address <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("address like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("address not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("address in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("address not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("address between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("address not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andPriceStrategyIsNull() {
            addCriterion("price_strategy is null");
            return (Criteria) this;
        }

        public Criteria andPriceStrategyIsNotNull() {
            addCriterion("price_strategy is not null");
            return (Criteria) this;
        }

        public Criteria andPriceStrategyEqualTo(Long value) {
            addCriterion("price_strategy =", value, "priceStrategy");
            return (Criteria) this;
        }

        public Criteria andPriceStrategyNotEqualTo(Long value) {
            addCriterion("price_strategy <>", value, "priceStrategy");
            return (Criteria) this;
        }

        public Criteria andPriceStrategyGreaterThan(Long value) {
            addCriterion("price_strategy >", value, "priceStrategy");
            return (Criteria) this;
        }

        public Criteria andPriceStrategyGreaterThanOrEqualTo(Long value) {
            addCriterion("price_strategy >=", value, "priceStrategy");
            return (Criteria) this;
        }

        public Criteria andPriceStrategyLessThan(Long value) {
            addCriterion("price_strategy <", value, "priceStrategy");
            return (Criteria) this;
        }

        public Criteria andPriceStrategyLessThanOrEqualTo(Long value) {
            addCriterion("price_strategy <=", value, "priceStrategy");
            return (Criteria) this;
        }

        public Criteria andPriceStrategyIn(List<Long> values) {
            addCriterion("price_strategy in", values, "priceStrategy");
            return (Criteria) this;
        }

        public Criteria andPriceStrategyNotIn(List<Long> values) {
            addCriterion("price_strategy not in", values, "priceStrategy");
            return (Criteria) this;
        }

        public Criteria andPriceStrategyBetween(Long value1, Long value2) {
            addCriterion("price_strategy between", value1, value2, "priceStrategy");
            return (Criteria) this;
        }

        public Criteria andPriceStrategyNotBetween(Long value1, Long value2) {
            addCriterion("price_strategy not between", value1, value2, "priceStrategy");
            return (Criteria) this;
        }

        public Criteria andPasswordIsNull() {
            addCriterion("password is null");
            return (Criteria) this;
        }

        public Criteria andPasswordIsNotNull() {
            addCriterion("password is not null");
            return (Criteria) this;
        }

        public Criteria andPasswordEqualTo(String value) {
            addCriterion("password =", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotEqualTo(String value) {
            addCriterion("password <>", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordGreaterThan(String value) {
            addCriterion("password >", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordGreaterThanOrEqualTo(String value) {
            addCriterion("password >=", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLessThan(String value) {
            addCriterion("password <", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLessThanOrEqualTo(String value) {
            addCriterion("password <=", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLike(String value) {
            addCriterion("password like", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotLike(String value) {
            addCriterion("password not like", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordIn(List<String> values) {
            addCriterion("password in", values, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotIn(List<String> values) {
            addCriterion("password not in", values, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordBetween(String value1, String value2) {
            addCriterion("password between", value1, value2, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotBetween(String value1, String value2) {
            addCriterion("password not between", value1, value2, "password");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("deleted is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("deleted is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Boolean value) {
            addCriterion("deleted =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Boolean value) {
            addCriterion("deleted <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Boolean value) {
            addCriterion("deleted >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("deleted >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Boolean value) {
            addCriterion("deleted <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Boolean value) {
            addCriterion("deleted <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Boolean> values) {
            addCriterion("deleted in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Boolean> values) {
            addCriterion("deleted not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Boolean value1, Boolean value2) {
            addCriterion("deleted between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("deleted not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andApprovedIsNull() {
            addCriterion("approved is null");
            return (Criteria) this;
        }

        public Criteria andApprovedIsNotNull() {
            addCriterion("approved is not null");
            return (Criteria) this;
        }

        public Criteria andApprovedEqualTo(Boolean value) {
            addCriterion("approved =", value, "approved");
            return (Criteria) this;
        }

        public Criteria andApprovedNotEqualTo(Boolean value) {
            addCriterion("approved <>", value, "approved");
            return (Criteria) this;
        }

        public Criteria andApprovedGreaterThan(Boolean value) {
            addCriterion("approved >", value, "approved");
            return (Criteria) this;
        }

        public Criteria andApprovedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("approved >=", value, "approved");
            return (Criteria) this;
        }

        public Criteria andApprovedLessThan(Boolean value) {
            addCriterion("approved <", value, "approved");
            return (Criteria) this;
        }

        public Criteria andApprovedLessThanOrEqualTo(Boolean value) {
            addCriterion("approved <=", value, "approved");
            return (Criteria) this;
        }

        public Criteria andApprovedIn(List<Boolean> values) {
            addCriterion("approved in", values, "approved");
            return (Criteria) this;
        }

        public Criteria andApprovedNotIn(List<Boolean> values) {
            addCriterion("approved not in", values, "approved");
            return (Criteria) this;
        }

        public Criteria andApprovedBetween(Boolean value1, Boolean value2) {
            addCriterion("approved between", value1, value2, "approved");
            return (Criteria) this;
        }

        public Criteria andApprovedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("approved not between", value1, value2, "approved");
            return (Criteria) this;
        }

        public Criteria andPermissIsNull() {
            addCriterion("permiss is null");
            return (Criteria) this;
        }

        public Criteria andPermissIsNotNull() {
            addCriterion("permiss is not null");
            return (Criteria) this;
        }

        public Criteria andPermissEqualTo(Integer value) {
            addCriterion("permiss =", value, "permiss");
            return (Criteria) this;
        }

        public Criteria andPermissNotEqualTo(Integer value) {
            addCriterion("permiss <>", value, "permiss");
            return (Criteria) this;
        }

        public Criteria andPermissGreaterThan(Integer value) {
            addCriterion("permiss >", value, "permiss");
            return (Criteria) this;
        }

        public Criteria andPermissGreaterThanOrEqualTo(Integer value) {
            addCriterion("permiss >=", value, "permiss");
            return (Criteria) this;
        }

        public Criteria andPermissLessThan(Integer value) {
            addCriterion("permiss <", value, "permiss");
            return (Criteria) this;
        }

        public Criteria andPermissLessThanOrEqualTo(Integer value) {
            addCriterion("permiss <=", value, "permiss");
            return (Criteria) this;
        }

        public Criteria andPermissIn(List<Integer> values) {
            addCriterion("permiss in", values, "permiss");
            return (Criteria) this;
        }

        public Criteria andPermissNotIn(List<Integer> values) {
            addCriterion("permiss not in", values, "permiss");
            return (Criteria) this;
        }

        public Criteria andPermissBetween(Integer value1, Integer value2) {
            addCriterion("permiss between", value1, value2, "permiss");
            return (Criteria) this;
        }

        public Criteria andPermissNotBetween(Integer value1, Integer value2) {
            addCriterion("permiss not between", value1, value2, "permiss");
            return (Criteria) this;
        }

        public Criteria andWuliuCodeIsNull() {
            addCriterion("wuliu_code is null");
            return (Criteria) this;
        }

        public Criteria andWuliuCodeIsNotNull() {
            addCriterion("wuliu_code is not null");
            return (Criteria) this;
        }

        public Criteria andWuliuCodeEqualTo(String value) {
            addCriterion("wuliu_code =", value, "wuliuCode");
            return (Criteria) this;
        }

        public Criteria andWuliuCodeNotEqualTo(String value) {
            addCriterion("wuliu_code <>", value, "wuliuCode");
            return (Criteria) this;
        }

        public Criteria andWuliuCodeGreaterThan(String value) {
            addCriterion("wuliu_code >", value, "wuliuCode");
            return (Criteria) this;
        }

        public Criteria andWuliuCodeGreaterThanOrEqualTo(String value) {
            addCriterion("wuliu_code >=", value, "wuliuCode");
            return (Criteria) this;
        }

        public Criteria andWuliuCodeLessThan(String value) {
            addCriterion("wuliu_code <", value, "wuliuCode");
            return (Criteria) this;
        }

        public Criteria andWuliuCodeLessThanOrEqualTo(String value) {
            addCriterion("wuliu_code <=", value, "wuliuCode");
            return (Criteria) this;
        }

        public Criteria andWuliuCodeLike(String value) {
            addCriterion("wuliu_code like", value, "wuliuCode");
            return (Criteria) this;
        }

        public Criteria andWuliuCodeNotLike(String value) {
            addCriterion("wuliu_code not like", value, "wuliuCode");
            return (Criteria) this;
        }

        public Criteria andWuliuCodeIn(List<String> values) {
            addCriterion("wuliu_code in", values, "wuliuCode");
            return (Criteria) this;
        }

        public Criteria andWuliuCodeNotIn(List<String> values) {
            addCriterion("wuliu_code not in", values, "wuliuCode");
            return (Criteria) this;
        }

        public Criteria andWuliuCodeBetween(String value1, String value2) {
            addCriterion("wuliu_code between", value1, value2, "wuliuCode");
            return (Criteria) this;
        }

        public Criteria andWuliuCodeNotBetween(String value1, String value2) {
            addCriterion("wuliu_code not between", value1, value2, "wuliuCode");
            return (Criteria) this;
        }

        public Criteria andWuliuNameIsNull() {
            addCriterion("wuliu_name is null");
            return (Criteria) this;
        }

        public Criteria andWuliuNameIsNotNull() {
            addCriterion("wuliu_name is not null");
            return (Criteria) this;
        }

        public Criteria andWuliuNameEqualTo(String value) {
            addCriterion("wuliu_name =", value, "wuliuName");
            return (Criteria) this;
        }

        public Criteria andWuliuNameNotEqualTo(String value) {
            addCriterion("wuliu_name <>", value, "wuliuName");
            return (Criteria) this;
        }

        public Criteria andWuliuNameGreaterThan(String value) {
            addCriterion("wuliu_name >", value, "wuliuName");
            return (Criteria) this;
        }

        public Criteria andWuliuNameGreaterThanOrEqualTo(String value) {
            addCriterion("wuliu_name >=", value, "wuliuName");
            return (Criteria) this;
        }

        public Criteria andWuliuNameLessThan(String value) {
            addCriterion("wuliu_name <", value, "wuliuName");
            return (Criteria) this;
        }

        public Criteria andWuliuNameLessThanOrEqualTo(String value) {
            addCriterion("wuliu_name <=", value, "wuliuName");
            return (Criteria) this;
        }

        public Criteria andWuliuNameLike(String value) {
            addCriterion("wuliu_name like", value, "wuliuName");
            return (Criteria) this;
        }

        public Criteria andWuliuNameNotLike(String value) {
            addCriterion("wuliu_name not like", value, "wuliuName");
            return (Criteria) this;
        }

        public Criteria andWuliuNameIn(List<String> values) {
            addCriterion("wuliu_name in", values, "wuliuName");
            return (Criteria) this;
        }

        public Criteria andWuliuNameNotIn(List<String> values) {
            addCriterion("wuliu_name not in", values, "wuliuName");
            return (Criteria) this;
        }

        public Criteria andWuliuNameBetween(String value1, String value2) {
            addCriterion("wuliu_name between", value1, value2, "wuliuName");
            return (Criteria) this;
        }

        public Criteria andWuliuNameNotBetween(String value1, String value2) {
            addCriterion("wuliu_name not between", value1, value2, "wuliuName");
            return (Criteria) this;
        }

        public Criteria andWuliuOrderIsNull() {
            addCriterion("wuliu_order is null");
            return (Criteria) this;
        }

        public Criteria andWuliuOrderIsNotNull() {
            addCriterion("wuliu_order is not null");
            return (Criteria) this;
        }

        public Criteria andWuliuOrderEqualTo(Integer value) {
            addCriterion("wuliu_order =", value, "wuliuOrder");
            return (Criteria) this;
        }

        public Criteria andWuliuOrderNotEqualTo(Integer value) {
            addCriterion("wuliu_order <>", value, "wuliuOrder");
            return (Criteria) this;
        }

        public Criteria andWuliuOrderGreaterThan(Integer value) {
            addCriterion("wuliu_order >", value, "wuliuOrder");
            return (Criteria) this;
        }

        public Criteria andWuliuOrderGreaterThanOrEqualTo(Integer value) {
            addCriterion("wuliu_order >=", value, "wuliuOrder");
            return (Criteria) this;
        }

        public Criteria andWuliuOrderLessThan(Integer value) {
            addCriterion("wuliu_order <", value, "wuliuOrder");
            return (Criteria) this;
        }

        public Criteria andWuliuOrderLessThanOrEqualTo(Integer value) {
            addCriterion("wuliu_order <=", value, "wuliuOrder");
            return (Criteria) this;
        }

        public Criteria andWuliuOrderIn(List<Integer> values) {
            addCriterion("wuliu_order in", values, "wuliuOrder");
            return (Criteria) this;
        }

        public Criteria andWuliuOrderNotIn(List<Integer> values) {
            addCriterion("wuliu_order not in", values, "wuliuOrder");
            return (Criteria) this;
        }

        public Criteria andWuliuOrderBetween(Integer value1, Integer value2) {
            addCriterion("wuliu_order between", value1, value2, "wuliuOrder");
            return (Criteria) this;
        }

        public Criteria andWuliuOrderNotBetween(Integer value1, Integer value2) {
            addCriterion("wuliu_order not between", value1, value2, "wuliuOrder");
            return (Criteria) this;
        }

        public Criteria andOrderQtyIsNull() {
            addCriterion("order_qty is null");
            return (Criteria) this;
        }

        public Criteria andOrderQtyIsNotNull() {
            addCriterion("order_qty is not null");
            return (Criteria) this;
        }

        public Criteria andOrderQtyEqualTo(Integer value) {
            addCriterion("order_qty =", value, "orderQty");
            return (Criteria) this;
        }

        public Criteria andOrderQtyNotEqualTo(Integer value) {
            addCriterion("order_qty <>", value, "orderQty");
            return (Criteria) this;
        }

        public Criteria andOrderQtyGreaterThan(Integer value) {
            addCriterion("order_qty >", value, "orderQty");
            return (Criteria) this;
        }

        public Criteria andOrderQtyGreaterThanOrEqualTo(Integer value) {
            addCriterion("order_qty >=", value, "orderQty");
            return (Criteria) this;
        }

        public Criteria andOrderQtyLessThan(Integer value) {
            addCriterion("order_qty <", value, "orderQty");
            return (Criteria) this;
        }

        public Criteria andOrderQtyLessThanOrEqualTo(Integer value) {
            addCriterion("order_qty <=", value, "orderQty");
            return (Criteria) this;
        }

        public Criteria andOrderQtyIn(List<Integer> values) {
            addCriterion("order_qty in", values, "orderQty");
            return (Criteria) this;
        }

        public Criteria andOrderQtyNotIn(List<Integer> values) {
            addCriterion("order_qty not in", values, "orderQty");
            return (Criteria) this;
        }

        public Criteria andOrderQtyBetween(Integer value1, Integer value2) {
            addCriterion("order_qty between", value1, value2, "orderQty");
            return (Criteria) this;
        }

        public Criteria andOrderQtyNotBetween(Integer value1, Integer value2) {
            addCriterion("order_qty not between", value1, value2, "orderQty");
            return (Criteria) this;
        }

        public Criteria andFreightIsNull() {
            addCriterion("freight is null");
            return (Criteria) this;
        }

        public Criteria andFreightIsNotNull() {
            addCriterion("freight is not null");
            return (Criteria) this;
        }

        public Criteria andFreightEqualTo(Integer value) {
            addCriterion("freight =", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightNotEqualTo(Integer value) {
            addCriterion("freight <>", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightGreaterThan(Integer value) {
            addCriterion("freight >", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightGreaterThanOrEqualTo(Integer value) {
            addCriterion("freight >=", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightLessThan(Integer value) {
            addCriterion("freight <", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightLessThanOrEqualTo(Integer value) {
            addCriterion("freight <=", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightIn(List<Integer> values) {
            addCriterion("freight in", values, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightNotIn(List<Integer> values) {
            addCriterion("freight not in", values, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightBetween(Integer value1, Integer value2) {
            addCriterion("freight between", value1, value2, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightNotBetween(Integer value1, Integer value2) {
            addCriterion("freight not between", value1, value2, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightFeeIsNull() {
            addCriterion("freight_fee is null");
            return (Criteria) this;
        }

        public Criteria andFreightFeeIsNotNull() {
            addCriterion("freight_fee is not null");
            return (Criteria) this;
        }

        public Criteria andFreightFeeEqualTo(Integer value) {
            addCriterion("freight_fee =", value, "freightFee");
            return (Criteria) this;
        }

        public Criteria andFreightFeeNotEqualTo(Integer value) {
            addCriterion("freight_fee <>", value, "freightFee");
            return (Criteria) this;
        }

        public Criteria andFreightFeeGreaterThan(Integer value) {
            addCriterion("freight_fee >", value, "freightFee");
            return (Criteria) this;
        }

        public Criteria andFreightFeeGreaterThanOrEqualTo(Integer value) {
            addCriterion("freight_fee >=", value, "freightFee");
            return (Criteria) this;
        }

        public Criteria andFreightFeeLessThan(Integer value) {
            addCriterion("freight_fee <", value, "freightFee");
            return (Criteria) this;
        }

        public Criteria andFreightFeeLessThanOrEqualTo(Integer value) {
            addCriterion("freight_fee <=", value, "freightFee");
            return (Criteria) this;
        }

        public Criteria andFreightFeeIn(List<Integer> values) {
            addCriterion("freight_fee in", values, "freightFee");
            return (Criteria) this;
        }

        public Criteria andFreightFeeNotIn(List<Integer> values) {
            addCriterion("freight_fee not in", values, "freightFee");
            return (Criteria) this;
        }

        public Criteria andFreightFeeBetween(Integer value1, Integer value2) {
            addCriterion("freight_fee between", value1, value2, "freightFee");
            return (Criteria) this;
        }

        public Criteria andFreightFeeNotBetween(Integer value1, Integer value2) {
            addCriterion("freight_fee not between", value1, value2, "freightFee");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(LocalDateTime value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(LocalDateTime value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(LocalDateTime value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(LocalDateTime value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<LocalDateTime> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<LocalDateTime> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("create_user is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("create_user is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("create_user =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("create_user <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("create_user >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("create_user >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("create_user <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("create_user <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("create_user like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("create_user not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("create_user in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("create_user not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("create_user between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("create_user not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(LocalDateTime value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(LocalDateTime value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(LocalDateTime value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(LocalDateTime value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<LocalDateTime> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<LocalDateTime> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("update_user is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("update_user is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("update_user =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("update_user <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("update_user >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("update_user >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("update_user <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("update_user <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("update_user like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("update_user not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("update_user in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("update_user not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("update_user between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("update_user not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andVersionIsNull() {
            addCriterion("version is null");
            return (Criteria) this;
        }

        public Criteria andVersionIsNotNull() {
            addCriterion("version is not null");
            return (Criteria) this;
        }

        public Criteria andVersionEqualTo(Long value) {
            addCriterion("version =", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotEqualTo(Long value) {
            addCriterion("version <>", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionGreaterThan(Long value) {
            addCriterion("version >", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionGreaterThanOrEqualTo(Long value) {
            addCriterion("version >=", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionLessThan(Long value) {
            addCriterion("version <", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionLessThanOrEqualTo(Long value) {
            addCriterion("version <=", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionIn(List<Long> values) {
            addCriterion("version in", values, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotIn(List<Long> values) {
            addCriterion("version not in", values, "version");
            return (Criteria) this;
        }

        public Criteria andVersionBetween(Long value1, Long value2) {
            addCriterion("version between", value1, value2, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotBetween(Long value1, Long value2) {
            addCriterion("version not between", value1, value2, "version");
            return (Criteria) this;
        }

        public Criteria andLockedIsNull() {
            addCriterion("locked is null");
            return (Criteria) this;
        }

        public Criteria andLockedIsNotNull() {
            addCriterion("locked is not null");
            return (Criteria) this;
        }

        public Criteria andLockedEqualTo(Boolean value) {
            addCriterion("locked =", value, "locked");
            return (Criteria) this;
        }

        public Criteria andLockedNotEqualTo(Boolean value) {
            addCriterion("locked <>", value, "locked");
            return (Criteria) this;
        }

        public Criteria andLockedGreaterThan(Boolean value) {
            addCriterion("locked >", value, "locked");
            return (Criteria) this;
        }

        public Criteria andLockedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("locked >=", value, "locked");
            return (Criteria) this;
        }

        public Criteria andLockedLessThan(Boolean value) {
            addCriterion("locked <", value, "locked");
            return (Criteria) this;
        }

        public Criteria andLockedLessThanOrEqualTo(Boolean value) {
            addCriterion("locked <=", value, "locked");
            return (Criteria) this;
        }

        public Criteria andLockedIn(List<Boolean> values) {
            addCriterion("locked in", values, "locked");
            return (Criteria) this;
        }

        public Criteria andLockedNotIn(List<Boolean> values) {
            addCriterion("locked not in", values, "locked");
            return (Criteria) this;
        }

        public Criteria andLockedBetween(Boolean value1, Boolean value2) {
            addCriterion("locked between", value1, value2, "locked");
            return (Criteria) this;
        }

        public Criteria andLockedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("locked not between", value1, value2, "locked");
            return (Criteria) this;
        }

        public Criteria andShoukuanCodeIsNull() {
            addCriterion("shoukuan_code is null");
            return (Criteria) this;
        }

        public Criteria andShoukuanCodeIsNotNull() {
            addCriterion("shoukuan_code is not null");
            return (Criteria) this;
        }

        public Criteria andShoukuanCodeEqualTo(String value) {
            addCriterion("shoukuan_code =", value, "shoukuanCode");
            return (Criteria) this;
        }

        public Criteria andShoukuanCodeNotEqualTo(String value) {
            addCriterion("shoukuan_code <>", value, "shoukuanCode");
            return (Criteria) this;
        }

        public Criteria andShoukuanCodeGreaterThan(String value) {
            addCriterion("shoukuan_code >", value, "shoukuanCode");
            return (Criteria) this;
        }

        public Criteria andShoukuanCodeGreaterThanOrEqualTo(String value) {
            addCriterion("shoukuan_code >=", value, "shoukuanCode");
            return (Criteria) this;
        }

        public Criteria andShoukuanCodeLessThan(String value) {
            addCriterion("shoukuan_code <", value, "shoukuanCode");
            return (Criteria) this;
        }

        public Criteria andShoukuanCodeLessThanOrEqualTo(String value) {
            addCriterion("shoukuan_code <=", value, "shoukuanCode");
            return (Criteria) this;
        }

        public Criteria andShoukuanCodeLike(String value) {
            addCriterion("shoukuan_code like", value, "shoukuanCode");
            return (Criteria) this;
        }

        public Criteria andShoukuanCodeNotLike(String value) {
            addCriterion("shoukuan_code not like", value, "shoukuanCode");
            return (Criteria) this;
        }

        public Criteria andShoukuanCodeIn(List<String> values) {
            addCriterion("shoukuan_code in", values, "shoukuanCode");
            return (Criteria) this;
        }

        public Criteria andShoukuanCodeNotIn(List<String> values) {
            addCriterion("shoukuan_code not in", values, "shoukuanCode");
            return (Criteria) this;
        }

        public Criteria andShoukuanCodeBetween(String value1, String value2) {
            addCriterion("shoukuan_code between", value1, value2, "shoukuanCode");
            return (Criteria) this;
        }

        public Criteria andShoukuanCodeNotBetween(String value1, String value2) {
            addCriterion("shoukuan_code not between", value1, value2, "shoukuanCode");
            return (Criteria) this;
        }

        public Criteria andShoukuanNameIsNull() {
            addCriterion("shoukuan_name is null");
            return (Criteria) this;
        }

        public Criteria andShoukuanNameIsNotNull() {
            addCriterion("shoukuan_name is not null");
            return (Criteria) this;
        }

        public Criteria andShoukuanNameEqualTo(String value) {
            addCriterion("shoukuan_name =", value, "shoukuanName");
            return (Criteria) this;
        }

        public Criteria andShoukuanNameNotEqualTo(String value) {
            addCriterion("shoukuan_name <>", value, "shoukuanName");
            return (Criteria) this;
        }

        public Criteria andShoukuanNameGreaterThan(String value) {
            addCriterion("shoukuan_name >", value, "shoukuanName");
            return (Criteria) this;
        }

        public Criteria andShoukuanNameGreaterThanOrEqualTo(String value) {
            addCriterion("shoukuan_name >=", value, "shoukuanName");
            return (Criteria) this;
        }

        public Criteria andShoukuanNameLessThan(String value) {
            addCriterion("shoukuan_name <", value, "shoukuanName");
            return (Criteria) this;
        }

        public Criteria andShoukuanNameLessThanOrEqualTo(String value) {
            addCriterion("shoukuan_name <=", value, "shoukuanName");
            return (Criteria) this;
        }

        public Criteria andShoukuanNameLike(String value) {
            addCriterion("shoukuan_name like", value, "shoukuanName");
            return (Criteria) this;
        }

        public Criteria andShoukuanNameNotLike(String value) {
            addCriterion("shoukuan_name not like", value, "shoukuanName");
            return (Criteria) this;
        }

        public Criteria andShoukuanNameIn(List<String> values) {
            addCriterion("shoukuan_name in", values, "shoukuanName");
            return (Criteria) this;
        }

        public Criteria andShoukuanNameNotIn(List<String> values) {
            addCriterion("shoukuan_name not in", values, "shoukuanName");
            return (Criteria) this;
        }

        public Criteria andShoukuanNameBetween(String value1, String value2) {
            addCriterion("shoukuan_name between", value1, value2, "shoukuanName");
            return (Criteria) this;
        }

        public Criteria andShoukuanNameNotBetween(String value1, String value2) {
            addCriterion("shoukuan_name not between", value1, value2, "shoukuanName");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeIsNull() {
            addCriterion("company_code is null");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeIsNotNull() {
            addCriterion("company_code is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeEqualTo(String value) {
            addCriterion("company_code =", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeNotEqualTo(String value) {
            addCriterion("company_code <>", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeGreaterThan(String value) {
            addCriterion("company_code >", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeGreaterThanOrEqualTo(String value) {
            addCriterion("company_code >=", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeLessThan(String value) {
            addCriterion("company_code <", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeLessThanOrEqualTo(String value) {
            addCriterion("company_code <=", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeLike(String value) {
            addCriterion("company_code like", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeNotLike(String value) {
            addCriterion("company_code not like", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeIn(List<String> values) {
            addCriterion("company_code in", values, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeNotIn(List<String> values) {
            addCriterion("company_code not in", values, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeBetween(String value1, String value2) {
            addCriterion("company_code between", value1, value2, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeNotBetween(String value1, String value2) {
            addCriterion("company_code not between", value1, value2, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIsNull() {
            addCriterion("company_name is null");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIsNotNull() {
            addCriterion("company_name is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyNameEqualTo(String value) {
            addCriterion("company_name =", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotEqualTo(String value) {
            addCriterion("company_name <>", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameGreaterThan(String value) {
            addCriterion("company_name >", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameGreaterThanOrEqualTo(String value) {
            addCriterion("company_name >=", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLessThan(String value) {
            addCriterion("company_name <", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLessThanOrEqualTo(String value) {
            addCriterion("company_name <=", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLike(String value) {
            addCriterion("company_name like", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotLike(String value) {
            addCriterion("company_name not like", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIn(List<String> values) {
            addCriterion("company_name in", values, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotIn(List<String> values) {
            addCriterion("company_name not in", values, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameBetween(String value1, String value2) {
            addCriterion("company_name between", value1, value2, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotBetween(String value1, String value2) {
            addCriterion("company_name not between", value1, value2, "companyName");
            return (Criteria) this;
        }

        public Criteria andDepositAmountIsNull() {
            addCriterion("deposit_amount is null");
            return (Criteria) this;
        }

        public Criteria andDepositAmountIsNotNull() {
            addCriterion("deposit_amount is not null");
            return (Criteria) this;
        }

        public Criteria andDepositAmountEqualTo(Double value) {
            addCriterion("deposit_amount =", value, "depositAmount");
            return (Criteria) this;
        }

        public Criteria andDepositAmountNotEqualTo(Double value) {
            addCriterion("deposit_amount <>", value, "depositAmount");
            return (Criteria) this;
        }

        public Criteria andDepositAmountGreaterThan(Double value) {
            addCriterion("deposit_amount >", value, "depositAmount");
            return (Criteria) this;
        }

        public Criteria andDepositAmountGreaterThanOrEqualTo(Double value) {
            addCriterion("deposit_amount >=", value, "depositAmount");
            return (Criteria) this;
        }

        public Criteria andDepositAmountLessThan(Double value) {
            addCriterion("deposit_amount <", value, "depositAmount");
            return (Criteria) this;
        }

        public Criteria andDepositAmountLessThanOrEqualTo(Double value) {
            addCriterion("deposit_amount <=", value, "depositAmount");
            return (Criteria) this;
        }

        public Criteria andDepositAmountIn(List<Double> values) {
            addCriterion("deposit_amount in", values, "depositAmount");
            return (Criteria) this;
        }

        public Criteria andDepositAmountNotIn(List<Double> values) {
            addCriterion("deposit_amount not in", values, "depositAmount");
            return (Criteria) this;
        }

        public Criteria andDepositAmountBetween(Double value1, Double value2) {
            addCriterion("deposit_amount between", value1, value2, "depositAmount");
            return (Criteria) this;
        }

        public Criteria andDepositAmountNotBetween(Double value1, Double value2) {
            addCriterion("deposit_amount not between", value1, value2, "depositAmount");
            return (Criteria) this;
        }

        public Criteria andLockAmountIsNull() {
            addCriterion("lock_amount is null");
            return (Criteria) this;
        }

        public Criteria andLockAmountIsNotNull() {
            addCriterion("lock_amount is not null");
            return (Criteria) this;
        }

        public Criteria andLockAmountEqualTo(Double value) {
            addCriterion("lock_amount =", value, "lockAmount");
            return (Criteria) this;
        }

        public Criteria andLockAmountNotEqualTo(Double value) {
            addCriterion("lock_amount <>", value, "lockAmount");
            return (Criteria) this;
        }

        public Criteria andLockAmountGreaterThan(Double value) {
            addCriterion("lock_amount >", value, "lockAmount");
            return (Criteria) this;
        }

        public Criteria andLockAmountGreaterThanOrEqualTo(Double value) {
            addCriterion("lock_amount >=", value, "lockAmount");
            return (Criteria) this;
        }

        public Criteria andLockAmountLessThan(Double value) {
            addCriterion("lock_amount <", value, "lockAmount");
            return (Criteria) this;
        }

        public Criteria andLockAmountLessThanOrEqualTo(Double value) {
            addCriterion("lock_amount <=", value, "lockAmount");
            return (Criteria) this;
        }

        public Criteria andLockAmountIn(List<Double> values) {
            addCriterion("lock_amount in", values, "lockAmount");
            return (Criteria) this;
        }

        public Criteria andLockAmountNotIn(List<Double> values) {
            addCriterion("lock_amount not in", values, "lockAmount");
            return (Criteria) this;
        }

        public Criteria andLockAmountBetween(Double value1, Double value2) {
            addCriterion("lock_amount between", value1, value2, "lockAmount");
            return (Criteria) this;
        }

        public Criteria andLockAmountNotBetween(Double value1, Double value2) {
            addCriterion("lock_amount not between", value1, value2, "lockAmount");
            return (Criteria) this;
        }

        public Criteria andNoDepositOrderIsNull() {
            addCriterion("no_deposit_order is null");
            return (Criteria) this;
        }

        public Criteria andNoDepositOrderIsNotNull() {
            addCriterion("no_deposit_order is not null");
            return (Criteria) this;
        }

        public Criteria andNoDepositOrderEqualTo(Boolean value) {
            addCriterion("no_deposit_order =", value, "noDepositOrder");
            return (Criteria) this;
        }

        public Criteria andNoDepositOrderNotEqualTo(Boolean value) {
            addCriterion("no_deposit_order <>", value, "noDepositOrder");
            return (Criteria) this;
        }

        public Criteria andNoDepositOrderGreaterThan(Boolean value) {
            addCriterion("no_deposit_order >", value, "noDepositOrder");
            return (Criteria) this;
        }

        public Criteria andNoDepositOrderGreaterThanOrEqualTo(Boolean value) {
            addCriterion("no_deposit_order >=", value, "noDepositOrder");
            return (Criteria) this;
        }

        public Criteria andNoDepositOrderLessThan(Boolean value) {
            addCriterion("no_deposit_order <", value, "noDepositOrder");
            return (Criteria) this;
        }

        public Criteria andNoDepositOrderLessThanOrEqualTo(Boolean value) {
            addCriterion("no_deposit_order <=", value, "noDepositOrder");
            return (Criteria) this;
        }

        public Criteria andNoDepositOrderIn(List<Boolean> values) {
            addCriterion("no_deposit_order in", values, "noDepositOrder");
            return (Criteria) this;
        }

        public Criteria andNoDepositOrderNotIn(List<Boolean> values) {
            addCriterion("no_deposit_order not in", values, "noDepositOrder");
            return (Criteria) this;
        }

        public Criteria andNoDepositOrderBetween(Boolean value1, Boolean value2) {
            addCriterion("no_deposit_order between", value1, value2, "noDepositOrder");
            return (Criteria) this;
        }

        public Criteria andNoDepositOrderNotBetween(Boolean value1, Boolean value2) {
            addCriterion("no_deposit_order not between", value1, value2, "noDepositOrder");
            return (Criteria) this;
        }

        public Criteria andOverDepositOrderIsNull() {
            addCriterion("over_deposit_order is null");
            return (Criteria) this;
        }

        public Criteria andOverDepositOrderIsNotNull() {
            addCriterion("over_deposit_order is not null");
            return (Criteria) this;
        }

        public Criteria andOverDepositOrderEqualTo(Boolean value) {
            addCriterion("over_deposit_order =", value, "overDepositOrder");
            return (Criteria) this;
        }

        public Criteria andOverDepositOrderNotEqualTo(Boolean value) {
            addCriterion("over_deposit_order <>", value, "overDepositOrder");
            return (Criteria) this;
        }

        public Criteria andOverDepositOrderGreaterThan(Boolean value) {
            addCriterion("over_deposit_order >", value, "overDepositOrder");
            return (Criteria) this;
        }

        public Criteria andOverDepositOrderGreaterThanOrEqualTo(Boolean value) {
            addCriterion("over_deposit_order >=", value, "overDepositOrder");
            return (Criteria) this;
        }

        public Criteria andOverDepositOrderLessThan(Boolean value) {
            addCriterion("over_deposit_order <", value, "overDepositOrder");
            return (Criteria) this;
        }

        public Criteria andOverDepositOrderLessThanOrEqualTo(Boolean value) {
            addCriterion("over_deposit_order <=", value, "overDepositOrder");
            return (Criteria) this;
        }

        public Criteria andOverDepositOrderIn(List<Boolean> values) {
            addCriterion("over_deposit_order in", values, "overDepositOrder");
            return (Criteria) this;
        }

        public Criteria andOverDepositOrderNotIn(List<Boolean> values) {
            addCriterion("over_deposit_order not in", values, "overDepositOrder");
            return (Criteria) this;
        }

        public Criteria andOverDepositOrderBetween(Boolean value1, Boolean value2) {
            addCriterion("over_deposit_order between", value1, value2, "overDepositOrder");
            return (Criteria) this;
        }

        public Criteria andOverDepositOrderNotBetween(Boolean value1, Boolean value2) {
            addCriterion("over_deposit_order not between", value1, value2, "overDepositOrder");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}